﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using Crosland.Automotriz.Core;
using System.Data.SqlClient;
namespace Crosland.Automotriz.Data.Dao.Linq
{
    public class clsLog_Imp_Mae_EstadoDAO
    {
        private AutomotrizEntities ContextoDeObjs = new AutomotrizEntities();

        public IEnumerable<Object> listar()
        {
            IEnumerable<Object> list = new List<Object>();
            try
            {
                var q = from l in ContextoDeObjs.T_IMP_IMPORTACION_ESTADO
                        where l.IND_BAJA != false
                        select new
                        {
                            l.IND_TRANSITO,
                            l.DES_IMP_SUP
                        };
                list = q.OrderBy(x=>x.IND_TRANSITO).Distinct().ToList();
            }
            catch
            {
                list = null;
            }
            return list;
        }


    }
}
